SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh' AND pod_kategorija = 'Kros' AND stil = 'HPC'
ORDER BY cena LIMIT 9,9
Airoh Strycker Shaded BLUE MATT
359,99 €
Airoh Strycker CRACK GLOSS
359,99 €
Airoh Aviator ACE Nemesi COLOR - BELA
419,99 €
Airoh Aviator ACE Color - črna
419,99 €
Airoh Aviator Riple
435,90 €
Airoh Aviator 2.2 Cairoli 019
589,99 € 435,90 €
Airoh Aviator Revolve
435,90 €
Airoh Aviator ACE Trick rumena-črna-plava
469,99 €
Airoh Aviator ACE Trick plava-bela-rdeča
469,99 €